{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Config","Generator"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":42,"n_cols":42,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,4,2],[10,0,10,2],[13,0,13,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[27,21,27,23],[28,21,28,23],[18,12,18,18],[18,3,18,11],[5,3,5,39],[17,3,17,39],[10,3,10,39],[13,3,13,39],[25,0,25,2],[18,19,18,23],[32,0,32,2],[33,0,33,2],[6,3,6,39],[7,3,7,39],[8,3,8,39],[12,0,12,2],[19,0,19,2],[19,3,19,39],[12,3,12,18],[12,19,12,25],[12,26,12,39],[25,33,25,35],[26,33,26,35],[27,33,27,35],[28,33,28,35],[32,33,32,35],[33,33,33,35],[25,27,25,29],[26,27,26,29],[27,27,27,29],[28,27,28,29],[32,27,32,29],[33,27,33,29],[26,21,26,23],[34,33,34,35],[35,33,35,35],[25,36,25,38],[26,36,26,38],[27,36,27,38],[28,36,28,38],[32,36,32,38],[33,36,33,38],[34,36,34,38],[35,36,35,38],[30,33,30,35],[30,36,30,38],[29,33,29,35],[29,36,29,38],[31,33,31,35],[31,36,31,38],[34,27,34,29],[35,27,35,29],[25,30,25,32],[26,30,26,32],[27,30,27,32],[28,30,28,32],[32,30,32,32],[33,30,33,32],[34,30,34,32],[35,30,35,32],[30,27,30,29],[30,30,30,32],[29,27,29,29],[29,30,29,32],[31,27,31,29],[31,30,31,32],[32,21,32,23],[33,21,33,23],[34,21,34,23],[35,21,35,23],[25,24,25,26],[26,24,26,26],[27,24,27,26],[28,24,28,26],[32,24,32,26],[33,24,33,26],[34,24,34,26],[35,24,35,26],[30,21,30,23],[30,24,30,26],[29,21,29,23],[29,24,29,26],[31,21,31,23],[31,24,31,26],[25,21,25,23],[35,15,35,17],[25,18,25,20],[26,18,26,20],[27,18,27,20],[28,18,28,20],[32,18,32,20],[33,18,33,20],[34,18,34,20],[35,18,35,20],[30,15,30,17],[30,18,30,20],[29,15,29,17],[29,18,29,20],[31,15,31,17],[31,18,31,20],[25,15,25,17],[26,15,26,17],[27,15,27,17],[28,15,28,17],[32,15,32,17],[33,15,33,17],[34,15,34,17],[35,9,35,11],[25,12,25,14],[26,12,26,14],[27,12,27,14],[28,12,28,14],[32,12,32,14],[33,12,33,14],[34,12,34,14],[35,12,35,14],[30,9,30,11],[30,12,30,14],[29,9,29,11],[29,12,29,14],[31,9,31,11],[31,12,31,14],[25,9,25,11],[26,9,26,11],[27,9,27,11],[28,9,28,11],[32,9,32,11],[33,9,33,11],[34,9,34,11],[25,6,25,8],[26,6,26,8],[27,6,27,8],[28,6,28,8],[32,6,32,8],[33,6,33,8],[34,6,34,8],[35,6,35,8],[30,3,30,5],[30,6,30,8],[29,3,29,5],[29,6,29,8],[31,3,31,5],[31,6,31,8],[25,3,25,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[34,41,34,44],[35,41,35,44],[14,0,16,2],[14,3,16,39],[25,41,25,44],[26,41,26,44],[27,41,27,44],[28,41,28,44],[22,3,22,39],[20,3,20,39],[18,35,18,39],[18,24,18,34],[23,0,23,39],[24,0,24,2],[26,0,26,2],[22,0,22,2],[18,0,18,2],[20,0,20,2],[27,0,27,2],[28,0,28,2],[34,0,34,2],[35,0,35,2],[17,0,17,2],[35,3,35,5],[5,1,5,2],[7,1,7,2],[9,1,9,2],[24,3,24,39],[11,0,11,2],[11,3,11,39],[0,34,0,36],[1,34,2,36],[0,28,0,30],[1,28,2,30],[0,31,0,33],[1,31,2,33],[0,37,0,39],[1,37,2,39],[0,3,1,18],[2,3,2,18],[0,19,0,27],[1,19,2,27],[3,12,3,18],[4,12,4,18],[4,19,4,39],[3,19,3,39],[9,3,9,39],[3,3,4,11]]}
[null,null,null,"COMPANY Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Status",null,null,null,null,null,null,null,null,"Type",null,null,"Discipline",null,null,"Number",null,null,"Rev",null,null,null,"${markup}"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(A41=\"POSITIVE\",Positive,IF(A41=\"NONE\",None&A40,IF(A41=\"NEGATIVE\",Negative,IF(A41=\"ABORTED\",Aborted,\"\")))),\"\")&IFERROR(CHAR(10)&IF(A42=\"Current\",Current,Previous),\"\")","v":"\nObsolete"},null,null,null,null,null,null,null,null,"${company_project_document_type}",null,null,"${company_project_package}",null,null,"${company_project_number}",null,null,"${company_project_revision}"]
[null,null,null,"${company_project_document_type:label}"]
[null,null,null,"${startdate}",null,null,null,null,null,null,null,null,"Workflow name",null,null,null,null,null,null,"${name}"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Filename",null,null,null,null,null,null,"${target.name}"]
["Rev","Date",null,"Reviews"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"${prevWorkflows.start}"]
["${card.company_project_revision}","${card.completedate}",null,"${card.company_project_review_description}"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"${prevWorkflows.end}"]
["${card.company_project_revision}","${card.completedate}",null,"${card.company_project_review_description}"]
["TITLE",null,null,"${company_project_title}"]
["DISCIPLINE",null,null,"${company_project_package:label}"]
["MANUFACTURER",null,null,"${company_project_manufacturer}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REF. PRODUCT",null,null,null,null,null,null,"${company_project_product}"]
["SUPPLIER",null,null,"${company_project_supplier}"]
["DESCRIPTION",null,null,"${company_project_explanation}"]
[]
[]
["REF. SPEC.",null,null,"${company_project_specifications}"]
["CONFORMITY",null,null,"${company_project_conformity:label}",null,null,null,null,null,null,null,null,"SAMPLE",null,null,null,null,null,null,"${company_project_sample:label}",null,null,null,null,"FIN. IMPACT",null,null,null,null,null,null,null,null,null,null,"${company_project_financial_impact:label}"]
["REF. PLAN",null,null,"${company_project_plan}"]
["ANNEXES",null,null,"${company_project_annexes}"]
[]
["REMARKS",null,null,{"$f":"IF(D31<>\"\",\"[\"&D26&\"] \"&D31&CHAR(10),\"\")&\nIF(G31<>\"\",\"[\"&G26&\"] \"&G31&CHAR(10),\"\")&\nIF(J31<>\"\",\"[\"&J26&\"] \"&J31&CHAR(10),\"\")&\nIF(M31<>\"\",\"[\"&M26&\"] \"&M31&CHAR(10),\"\")&\nIF(P31<>\"\",\"[\"&P26&\"] \"&P31&CHAR(10),\"\")&\nIF(S31<>\"\",\"[\"&S26&\"] \"&S31&CHAR(10),\"\")&\nIF(V31<>\"\",\"[\"&V26&\"] \"&V31&CHAR(10),\"\")&\nIF(Y31<>\"\",\"[\"&Y26&\"] \"&Y31&CHAR(10),\"\")&\nIF(AB31<>\"\",\"[\"&AB26&\"] \"&AB31&CHAR(10),\"\")&\nIF(AE31<>\"\",\"[\"&AE26&\"] \"&AE31&CHAR(10),\"\")&\nIF(AH31<>\"\",\"[\"&AH26&\"] \"&AH31&CHAR(10),\"\")&\nIF(AK31<>\"\",\"[\"&AK26&\"] \"&AK31&CHAR(10),\"\")","v":"[PM] $(actions.company_project_action_pm.company_project_comment)\n[AR] $(actions.company_project_action_ar.company_project_comment)\n[STAB] $(actions.company_project_action_stab.company_project_comment)\n[MEP] $(actions.company_project_action_mep.company_project_comment)\n"}]
["APPROVAL"]
["Statuses",null,null,{"$f":"Config!B10&\" (\"&Config!A10&\")\"\n&IF(Config!A11<>\"Undefined\",\" / \"&Config!B11&\" (\"&Config!A11&\")\",\"\")\n&IF(Config!A12<>\"Undefined\",\" / \"&Config!B12&\" (\"&Config!A12&\")\",\"\")\n&IF(Config!A13<>\"Undefined\",\" / \"&Config!B13&\" (\"&Config!A13&\")\",\"\")\n&IF(Config!A14<>\"Undefined\",\" / \"&Config!B14&\" (\"&Config!A14&\")\",\"\")\n&IF(Config!A15<>\"Undefined\",\" / \"&Config!B15&\" (\"&Config!A15&\")\",\"\")","v":"Approved (A) / Approved with remark (B) / Refused (C) / Non concerned (D)"}]
["ROLES",null,null,"PM",null,null,null,null,null,"AR",null,null,"STAB",null,null,"MEP"]
["Contributor?",null,null,{"$f":"IF(D28 <> \"\", \"X\", \"\")","v":"X"},null,null,{"$f":"IF(G28<> \"\", \"X\", \"\")","v":""},null,null,{"$f":"IF(J28 <> \"\", \"X\", \"\")","v":"X"},null,null,{"$f":"IF(M28 <> \"\", \"X\", \"\")","v":"X"},null,null,{"$f":"IF(P28 <> \"\", \"X\", \"\")","v":"X"},null,null,{"$f":"IF(S28<> \"\", \"X\", \"\")","v":""},null,null,{"$f":"IF(V28<> \"\", \"X\", \"\")","v":""},null,null,{"$f":"IF(Y28<> \"\", \"X\", \"\")","v":""},null,null,{"$f":"IF(AB28<> \"\", \"X\", \"\")","v":""},null,null,{"$f":"IF(AE28<> \"\", \"X\", \"\")","v":""},null,null,{"$f":"IF(AH28<> \"\", \"X\", \"\")","v":""},null,null,{"$f":"IF(AK28<> \"\", \"X\", \"\")","v":""}]
["Bijdrager",null,null,"$(company_project_pm)",null,null,null,null,null,"$(company_project_ar)",null,null,"$(company_project_stab)",null,null,"$(company_project_mep)"]
["Answer",null,null,"$(actions.company_project_action_pm.company_project_answer)",null,null,null,null,null,"$(actions.company_project_action_ar.company_project_answer)",null,null,"$(actions.company_project_action_stab.company_project_answer)",null,null,"$(actions.company_project_action_mep.company_project_answer)"]
["Date",null,null,"$(actions.company_project_action_pm.completedate)",null,null,null,null,null,"$(actions.company_project_action_ar.completedate)",null,null,"$(actions.company_project_action_stab.completedate)",null,null,"$(actions.company_project_action_mep.completedate)"]
["Commentaar",null,null,"$(actions.company_project_action_pm.company_project_comment)",null,null,null,null,null,"$(actions.company_project_action_ar.company_project_comment)",null,null,"$(actions.company_project_action_stab.company_project_comment)",null,null,"$(actions.company_project_action_mep.company_project_comment)"]
["Bijlagen",null,null,"$(actions.company_project_action_pm.attachment_count)",null,null,null,null,null,"$(actions.company_project_action_ar.attachment_count)",null,null,"$(actions.company_project_action_stab.attachment_count)",null,null,"$(actions.company_project_action_mep.attachment_count)"]
["Annotaties",null,null,"$(actions.company_project_action_pm.markup_count)",null,null,null,null,null,"$(actions.company_project_action_ar.markup_count)",null,null,"$(actions.company_project_action_stab.markup_count)",null,null,"$(actions.company_project_action_mep.markup_count)"]
["Comment?",null,null,{"$f":"IF(D31<>\"\",Config!$B$18,\"\")","v":"Yes"},null,null,null,null,null,{"$f":"IF(J31<>\"\",Config!$B$18,\"\")","v":"Yes"},null,null,{"$f":"IF(M31<>\"\",Config!$B$18,\"\")","v":"Yes"},null,null,{"$f":"IF(P31<>\"\",Config!$B$18,\"\")","v":"Yes"}]
["Attachments?",null,null,{"$f":"IF(D32>0,Config!$B$18&\" (\"&D33&\")\",\"\")","v":"Yes ($(actions.company_project_action_pm.markup_count))"},null,null,null,null,null,{"$f":"IF(J32>0,Config!$B$18&\" (\"&J33&\")\",\"\")","v":"Yes ($(actions.company_project_action_ar.markup_count))"},null,null,{"$f":"IF(M32>0,Config!$B$18&\" (\"&M33&\")\",\"\")","v":"Yes ($(actions.company_project_action_stab.markup_count))"},null,null,{"$f":"IF(P32>0,Config!$B$18&\" (\"&P33&\")\",\"\")","v":"Yes ($(actions.company_project_action_mep.markup_count))"}]
["Annotations?",null,null,{"$f":"IF(D33>0,Config!$B$18,\"\")","v":"Yes"},null,null,null,null,null,{"$f":"IF(J33>0,Config!$B$18,\"\")","v":"Yes"},null,null,{"$f":"IF(M33>0,Config!$B$18,\"\")","v":"Yes"},null,null,{"$f":"IF(P33>0,Config!$B$18,\"\")","v":"Yes"}]
[]
[]
["Values"]
["${current_step}"]
["${completed_status}"]
["${life_status}"]

{"sheet":"Config","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Statuses","Label"]
["Positive","APPROUVED"]
["Negative","REFUSED"]
["None"]
["Aborted","Aborted"]
["Previous","Obsolete"]
["Current","In force"]
[]
["Answers","Label"]
["A","Approved"]
["B","Approved with remark"]
["C","Refused"]
["D","Non concerned"]
["Undefined"]
["Undefined"]
[]
["Dictionnary","Translation"]
["Yes","Yes","Define word in own language"]
["No","No"]

{"sheet":"Generator","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,1,8,3],[9,1,9,3],[10,1,10,3],[17,1,17,3],[18,1,18,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3]]}
["Step 1 - Initialization - Define values in yellow blocks and click on button"]
["Key Prefix","company_project"]
["Role Suffix","mep"]
["Displayed Role","mep"]
["Answer Key Suffix","answer"]
["Comment Key Suffix","comment"]
[]
["Step 2 - Footer generator"]
["Role","MEP"]
["Contribute?",{"$f":"IF(B11 <> \"\", \"X\", \"\")","v":"X"}]
["Contributor","$(company_project_mep)"]
["Answer","$(actions.company_project_action_mep.company_project_answer)"]
["Date","$(actions.company_project_action_mep.completedate)"]
["Comment","$(actions.company_project_action_mep.company_project_comment)"]
["Attachments","$(actions.company_project_action_mep.attachment_count)"]
["Annotations","$(actions.company_project_action_mep.markup_count)"]
["Comments?",{"$f":"IF(B14<>\"\",Config!$B$18,\"\")","v":"Yes"}]
["Attachments?",{"$f":"IF(B15>0,Config!$B$18&\" (\"&B16&\")\",\"\")","v":"Yes ($(actions.company_project_action_mep.markup_count))"}]
["Annotations?",{"$f":"IF(B16>0,Config!$B$18,\"\")","v":"Yes"}]
[null,null,{"$f":"IF(C17>0,Config!$B$18,\"\")","v":""},{"$f":"IF(D17>0,Config!$B$18,\"\")","v":""}]
["Step 3 - Copy all rows and paster in cover footer as formulas"]